/ MacWorld 1998 February / Macworld (1998-02).dmg / Updaters / MacPOS Folder v97 / * MacPOS Help / Exporting

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 09 24 06 dc 45 78 | 70 6f 72 74 69 6e 67 0d |...$..Ex|porting.|
|00000010| 0d 45 78 70 6f 72 74 69 | 6e 67 ca 52 65 70 6f 72 |.Exporti|ng.Repor|
|00000020| 74 73 0d 0d 45 78 70 6f | 72 74 69 6e 67 20 69 73 |ts..Expo|rting is|
|00000030| 20 61 20 74 65 72 6d 20 | 75 73 65 64 20 77 68 65 | a term |used whe|
|00000040| 6e 20 61 20 64 61 74 61 | 62 61 73 65 20 70 72 6f |n a data|base pro|
|00000050| 67 72 61 6d 20 63 72 65 | 61 74 65 73 20 61 20 64 |gram cre|ates a d|
|00000060| 69 73 6b 20 66 69 6c 65 | 20 63 6f 6e 74 61 69 6e |isk file| contain|
|00000070| 69 6e 67 20 63 65 72 74 | 61 69 6e 20 66 69 65 6c |ing cert|ain fiel|
|00000080| 64 73 20 6f 72 20 61 6c | 6c 20 66 69 65 6c 64 73 |ds or al|l fields|
|00000090| 20 77 69 74 68 69 6e 20 | 74 68 65 20 64 61 74 61 | within |the data|
|000000a0| 62 61 73 65 20 61 6e 64 | 20 66 6f 72 6d 61 74 73 |base and| formats|
|000000b0| 20 69 74 20 73 6f 20 6f | 74 68 65 72 20 70 72 6f | it so o|ther pro|
|000000c0| 67 72 61 6d 73 20 63 61 | 6e 20 72 65 61 64 20 69 |grams ca|n read i|
|000000d0| 74 2e 20 20 4d 61 63 50 | 4f 53 20 75 73 65 73 20 |t.  MacP|OS uses |
|000000e0| 61 6e 20 41 53 43 49 49 | 20 54 61 62 20 64 65 6c |an ASCII| Tab del|
|000000f0| 69 6d 69 74 65 64 20 66 | 6f 72 6d 61 74 2e 20 20 |imited f|ormat.  |
|00000100| 54 68 69 73 20 6d 65 61 | 6e 73 20 74 68 61 74 20 |This mea|ns that |
|00000110| 61 20 54 41 42 20 63 68 | 61 72 61 63 74 65 72 20 |a TAB ch|aracter |
|00000120| 73 65 70 61 72 61 74 65 | 73 20 65 61 63 68 20 66 |separate|s each f|
|00000130| 69 65 6c 64 20 77 69 74 | 68 69 6e 20 74 68 65 20 |ield wit|hin the |
|00000140| 72 65 63 6f 72 64 73 20 | 74 68 61 74 20 61 72 65 |records |that are|
|00000150| 20 65 78 70 6f 72 74 65 | 64 2e 20 20 41 20 72 65 | exporte|d.  A re|
|00000160| 74 75 72 6e 20 20 69 73 | 20 74 68 65 20 6c 61 73 |turn  is| the las|
|00000170| 74 20 63 68 61 72 61 63 | 74 65 72 20 69 6e 20 65 |t charac|ter in e|
|00000180| 61 63 68 20 72 65 63 6f | 72 64 20 65 78 70 6f 72 |ach reco|rd expor|
|00000190| 74 65 64 2e 0d 0d 54 68 | 65 20 65 78 70 6f 72 74 |ted...Th|e export|
|000001a0| 65 64 20 72 65 70 6f 72 | 74 73 20 61 72 65 20 69 |ed repor|ts are i|
|000001b0| 6e 20 61 20 54 45 58 54 | 20 66 69 6c 65 20 74 79 |n a TEXT| file ty|
|000001c0| 70 65 20 61 6e 64 20 75 | 73 65 20 74 68 65 20 54 |pe and u|se the T|
|000001d0| 41 42 20 64 65 6c 69 6d | 69 74 65 64 20 66 69 6c |AB delim|ited fil|
|000001e0| 65 20 66 6f 72 6d 61 74 | 2e 20 54 68 65 73 65 20 |e format|. These |
|000001f0| 66 69 6c 65 73 20 63 61 | 6e 20 62 65 20 6f 70 65 |files ca|n be ope|
|00000200| 6e 65 64 20 62 79 20 57 | 6f 72 64 20 50 72 6f 63 |ned by W|ord Proc|
|00000210| 65 73 73 6f 72 2c 20 53 | 70 72 65 61 64 53 68 65 |essor, S|preadShe|
|00000220| 65 74 20 6f 72 20 44 61 | 74 61 62 61 73 65 20 70 |et or Da|tabase p|
|00000230| 72 6f 67 72 61 6d 73 2e | 20 20 0d 0d 54 68 65 73 |rograms.|  ..Thes|
|00000240| 65 20 70 72 6f 67 72 61 | 6d 73 20 69 6e 63 6c 75 |e progra|ms inclu|
|00000250| 64 65 20 3a 0d 4d 69 63 | 72 6f 73 6f 66 74 20 57 |de :.Mic|rosoft W|
|00000260| 6f 72 64 20 20 20 4d 69 | 63 72 6f 73 6f 66 74 20 |ord   Mi|crosoft |
|00000270| 57 6f 72 6b 73 20 20 20 | 20 4d 69 63 72 6f 73 6f |Works   | Microso|
|00000280| 66 74 20 45 78 63 65 6c | 20 20 20 20 20 20 20 43 |ft Excel|       C|
|00000290| 6c 61 72 69 73 20 57 6f | 72 6b 73 0d 42 65 61 67 |laris Wo|rks.Beag|
|000002a0| 6c 65 20 57 6f 72 6b 73 | 20 20 20 20 20 20 46 69 |le Works|      Fi|
|000002b0| 6c 65 4d 61 6b 65 72 20 | 20 20 20 20 20 20 20 20 |leMaker |        |
|000002c0| 20 20 20 20 20 46 69 6c | 65 4d 61 6b 65 72 20 50 |     Fil|eMaker P|
|000002d0| 72 6f 20 20 20 20 20 20 | 20 20 4c 6f 74 75 73 20 |ro      |  Lotus |
|000002e0| 31 32 33 0d 0d 59 6f 75 | 20 63 61 6e 20 6f 70 65 |123..You| can ope|
|000002f0| 6e 20 61 6e 79 20 65 78 | 70 6f 72 74 65 64 20 66 |n any ex|ported f|
|00000300| 69 6c 65 20 6f 72 20 54 | 45 58 54 20 66 69 6c 65 |ile or T|EXT file|
|00000310| 20 66 72 6f 6d 20 77 69 | 74 68 69 6e 20 4d 61 63 | from wi|thin Mac|
|00000320| 50 4f 53 20 62 79 20 73 | 65 6c 65 63 74 69 6e 67 |POS by s|electing|
|00000330| 20 54 65 78 74 20 66 72 | 6f 6d 20 74 68 65 20 57 | Text fr|om the W|
|00000340| 69 6e 64 6f 77 20 6d 65 | 6e 75 2c 20 74 68 65 6e |indow me|nu, then|
|00000350| 20 73 65 6c 65 63 74 20 | 4f 70 65 6e 20 66 72 6f | select |Open fro|
|00000360| 6d 20 74 68 65 20 46 69 | 6c 65 20 6d 65 6e 75 20 |m the Fi|le menu |
|00000370| 61 6e 64 20 74 68 65 6e | 20 73 65 6c 65 63 74 20 |and then| select |
|00000380| 74 68 65 20 45 78 70 6f | 72 74 65 64 20 74 65 78 |the Expo|rted tex|
|00000390| 74 20 66 69 6c 65 20 74 | 6f 20 76 69 65 77 2e 0d |t file t|o view..|
|000003a0| 0d 41 6e 20 65 78 61 6d | 70 6c 65 20 6f 66 20 61 |.An exam|ple of a|
|000003b0| 20 43 75 73 74 6f 6d 65 | 72 20 41 64 64 72 65 73 | Custome|r Addres|
|000003c0| 73 20 4c 69 73 74 20 45 | 78 70 6f 72 74 20 3a 0d |s List E|xport :.|
|000003d0| 54 68 65 20 66 69 72 73 | 74 20 6c 69 6e 65 20 69 |The firs|t line i|
|000003e0| 6e 20 74 68 65 20 65 78 | 70 6f 72 74 20 69 73 20 |n the ex|port is |
|000003f0| 74 68 65 20 66 69 65 6c | 64 20 6c 61 79 6f 75 74 |the fiel|d layout|
|00000400| 20 66 6f 72 20 74 68 65 | 20 65 78 70 6f 72 74 2e | for the| export.|
|00000410| 20 20 54 68 65 20 66 69 | 72 73 74 20 66 69 65 6c |  The fi|rst fiel|
|00000420| 64 20 69 73 20 63 61 6c | 6c 65 64 20 61 20 68 65 |d is cal|led a he|
|00000430| 61 64 65 72 20 66 69 65 | 6c 64 20 61 6e 64 20 63 |ader fie|ld and c|
|00000440| 61 6e 20 62 65 20 64 69 | 73 63 61 72 64 65 64 20 |an be di|scarded |
|00000450| 6f 72 20 72 65 6d 6f 76 | 65 64 20 69 6e 20 74 68 |or remov|ed in th|
|00000460| 65 20 64 61 74 61 62 61 | 73 65 20 6f 72 20 73 70 |e databa|se or sp|
|00000470| 72 65 61 64 73 68 65 65 | 74 20 70 72 6f 67 72 61 |readshee|t progra|
|00000480| 6d 20 74 68 61 74 20 79 | 6f 75 20 75 73 65 2e 20 |m that y|ou use. |
|00000490| 20 54 68 65 20 68 65 61 | 64 65 72 20 66 69 65 6c | The hea|der fiel|
|000004a0| 64 20 69 73 20 75 73 65 | 64 20 62 79 20 4d 61 63 |d is use|d by Mac|
|000004b0| 50 4f 53 20 66 6f 72 20 | 66 61 73 74 20 6f 70 65 |POS for |fast ope|
|000004c0| 6e 69 6e 67 20 61 6e 64 | 20 73 6f 72 74 69 6e 67 |ning and| sorting|
|000004d0| 20 6f 66 20 74 68 65 20 | 65 78 70 6f 72 74 65 64 | of the |exported|
|000004e0| 20 64 61 74 61 2e 20 20 | 4c 61 72 67 65 20 65 78 | data.  |Large ex|
|000004f0| 70 6f 72 74 73 20 62 79 | 20 4d 61 63 50 4f 53 20 |ports by| MacPOS |
|00000500| 61 72 65 20 76 65 72 79 | 20 66 61 73 74 20 77 68 |are very| fast wh|
|00000510| 65 6e 20 73 61 76 69 6e | 67 20 74 6f 20 64 69 73 |en savin|g to dis|
|00000520| 6b 20 62 65 63 61 75 73 | 65 20 6f 66 20 74 68 69 |k becaus|e of thi|
|00000530| 73 20 68 65 61 64 65 72 | 20 69 6e 66 6f 72 6d 61 |s header| informa|
|00000540| 74 69 6f 6e 2e 0d 0d 25 | a5 4e 61 6d 65 20 a5 41 |tion...%|.Name .A|
|00000550| 64 64 72 65 73 73 a5 43 | 69 74 79 a5 53 74 61 74 |ddress.C|ity.Stat|
|00000560| 65 a5 5a 69 70 a5 0d 40 | a5 53 74 65 76 65 20 43 |e.Zip..@|.Steve C|
|00000570| 72 6f 73 73 6d 61 6e a5 | 39 34 34 20 57 65 62 65 |rossman.|944 Webe|
|00000580| 72 20 4c 61 6e 65 a5 45 | 72 69 65 a5 50 41 a5 31 |r Lane.E|rie.PA.1|
|00000590| 36 35 30 39 0d 0d 54 68 | 65 20 a5 20 63 68 61 72 |6509..Th|e . char|
|000005a0| 61 63 74 65 72 73 20 72 | 65 70 72 65 73 65 6e 74 |acters r|epresent|
|000005b0| 73 20 74 68 65 20 54 41 | 42 20 63 68 61 72 61 63 |s the TA|B charac|
|000005c0| 74 65 72 2e 20 20 54 68 | 65 20 54 41 42 20 73 65 |ter.  Th|e TAB se|
|000005d0| 70 61 72 61 74 65 73 20 | 65 61 63 68 20 66 69 65 |parates |each fie|
|000005e0| 6c 64 20 69 6e 20 65 61 | 63 68 20 72 65 63 6f 72 |ld in ea|ch recor|
|000005f0| 64 20 69 6e 20 74 68 65 | 20 65 78 70 6f 72 74 65 |d in the| exporte|
|00000600| 64 20 66 69 6c 65 2e 20 | 20 54 61 62 73 20 61 72 |d file. | Tabs ar|
|00000610| 65 20 69 6e 76 69 73 69 | 62 6c 65 20 63 68 61 72 |e invisi|ble char|
|00000620| 61 63 74 65 72 73 20 69 | 6e 20 61 20 77 6f 72 64 |acters i|n a word|
|00000630| 20 70 72 6f 63 65 73 73 | 69 6e 67 20 64 6f 63 75 | process|ing docu|
|00000640| 6d 65 6e 74 20 61 6e 64 | 20 6d 6f 73 74 20 6f 74 |ment and| most ot|
|00000650| 68 65 72 20 70 72 6f 67 | 72 61 6d 73 2e 20 45 61 |her prog|rams. Ea|
|00000660| 63 68 20 66 69 65 6c 64 | 20 69 73 20 74 72 75 6e |ch field| is trun|
|00000670| 63 61 74 65 64 2c 20 28 | 20 62 6c 61 6e 6b 73 20 |cated, (| blanks |
|00000680| 61 72 65 20 72 65 6d 6f | 76 65 64 20 66 72 6f 6d |are remo|ved from|
|00000690| 20 74 68 65 20 72 69 67 | 68 74 20 74 6f 20 6c 65 | the rig|ht to le|
|000006a0| 66 74 20 29 2e 20 20 20 | 41 20 72 65 74 75 72 6e |ft ).   |A return|
|000006b0| 20 20 43 48 52 24 28 31 | 33 29 20 69 73 20 74 68 |  CHR$(1|3) is th|
|000006c0| 65 20 6c 61 73 74 20 63 | 68 61 72 61 63 74 65 72 |e last c|haracter|
|000006d0| 20 69 6e 20 65 61 63 68 | 20 72 65 63 6f 72 64 2e | in each| record.|
|000006e0| 0d 0d 00 1d 00 00 00 00 | 00 13 00 0e 00 14 00 00 |........|........|
|000006f0| 00 12 ff ff 00 00 00 00 | 00 00 00 0a 00 10 00 0c |........|........|
|00000700| 00 00 00 00 00 0c 00 00 | 00 00 00 00 00 00 00 0b |........|........|
|00000710| 00 0d 00 0a 00 03 05 00 | 00 0a 00 00 00 00 ff ff |........|........|
|00000720| 00 00 00 1c 00 10 00 0c | 00 00 01 00 00 0c 00 00 |........|........|
|00000730| 00 00 00 00 00 00 00 1e | 00 0c 00 0a 00 03 00 00 |........|........|
|00000740| 00 09 00 00 00 00 00 00 | 00 00 00 dd 00 0c 00 0a |........|........|
|00000750| 00 03 01 00 00 09 00 00 | 00 00 00 00 00 00 00 e6 |........|........|
|00000760| 00 0c 00 0a 00 03 00 00 | 00 09 00 00 00 00 00 00 |........|........|
|00000770| 00 00 01 58 00 0c 00 0a | 00 03 01 00 00 09 00 00 |...X....|........|
|00000780| 00 00 00 00 00 00 01 5e | 00 0c 00 0a 00 03 00 00 |.......^|........|
|00000790| 00 09 00 00 00 00 00 00 | 00 00 01 ae 00 0c 00 0a |........|........|
|000007a0| 00 03 01 00 00 09 00 00 | 00 00 00 00 00 00 01 b2 |........|........|
|000007b0| 00 0c 00 0a 00 03 00 00 | 00 09 00 00 00 00 00 00 |........|........|
|000007c0| 00 00 01 c9 00 0c 00 0a | 00 03 01 00 00 09 00 00 |........|........|
|000007d0| 00 00 00 00 00 00 01 cc | 00 0c 00 0a 00 03 00 00 |........|........|
|000007e0| 00 09 00 00 00 00 00 00 | 00 00 02 4f 00 0d 00 0a |........|...O....|
|000007f0| 00 03 01 00 00 0a 00 00 | 00 00 00 00 00 00 02 de |........|........|
|00000800| 00 0c 00 0a 00 03 00 00 | 00 09 00 00 00 00 00 00 |........|........|
|00000810| 00 00 03 2b 00 0c 00 0a | 00 03 01 00 00 09 00 00 |...+....|........|
|00000820| 00 00 00 00 00 00 03 2f | 00 0c 00 0a 00 03 00 00 |......./|........|
|00000830| 00 09 00 00 00 00 00 00 | 00 00 03 39 00 0c 00 0a |........|...9....|
|00000840| 00 03 01 00 00 09 00 00 | 00 00 00 00 00 00 03 3f |........|.......?|
|00000850| 00 0c 00 0a 00 03 00 00 | 00 09 00 00 00 00 00 00 |........|........|
|00000860| 00 00 03 52 00 0c 00 0a | 00 03 01 00 00 09 00 00 |...R....|........|
|00000870| 00 00 00 00 00 00 03 56 | 00 0c 00 0a 00 03 00 00 |.......V|........|
|00000880| 00 09 00 00 00 00 00 00 | 00 00 03 60 00 0c 00 0a |........|...`....|
|00000890| 00 03 01 00 00 09 00 00 | 00 00 00 00 00 00 03 64 |........|.......d|
|000008a0| 00 0c 00 0a 00 03 00 00 | 00 09 00 00 00 00 00 00 |........|........|
|000008b0| 00 00 03 9b 00 0c 00 0a | 00 03 01 00 00 09 00 00 |........|........|
|000008c0| 00 00 00 00 00 00 03 c9 | 00 0c 00 0a 00 03 00 00 |........|........|
|000008d0| 00 09 00 00 00 00 00 00 | 00 00 05 b0 00 0c 00 0a |........|........|
|000008e0| 00 03 01 00 00 09 00 00 | 00 00 00 00 00 00 05 b3 |........|........|
|000008f0| 00 0c 00 0a 00 03 00 00 | 00 09 00 00 00 00 00 00 |........|........|
|00000900| 00 00 06 a4 00 0c 00 0a | 00 03 01 00 00 09 00 00 |........|........|
|00000910| 00 00 00 00 00 00 06 aa | 00 0c 00 0a 00 03 00 00 |........|........|
|00000920| 00 09 00 00 00 00 00 00 |                         |........|        |
+--------+-------------------------+-------------------------+--------+--------+